*import .xlsx data from Desktop
import excel "C:\Users\vlada\OneDrive\Desktop\1. Central Government Debt (1971-2021).xlsx", sheet("DEBT-TO-GDP") firstrow
*declare imported Excel data set to be a time series data set
tsset YEAR, yearly
*open log file to store STATA resuls
log using "C:\Users\vlada\OneDrive\Desktop\Tables.smcl"
*compute descriptive statistics from Table 1
summarize
*compute autocorrelation and partial autocorrelation coefficents from Table 2 along with associated Q-statistics and its p-values
corrgram AUSTRALIA, lags(10)
corrgram AUSTRIA, lags(10)
corrgram BELGIUM, lags(10)
corrgram DENMARK, lags(10)
corrgram FINLAND, lags(10)
corrgram FRANCE, lags(10)
corrgram GERMANY, lags(10)
corrgram GREECE, lags(10)
corrgram ITALY, lags(10)
corrgram JAPAN, lags(10)
corrgram KOREA, lags(10)
corrgram LUXEMBOURG, lags(10)
corrgram NEWZEALAND, lags(10)
corrgram NORWAY, lags(10)
corrgram PORTUGAL, lags(10)
corrgram SINGAPORE, lags(10)
corrgram SPAIN, lags(10)
corrgram SWEDEN, lags(10)
corrgram US, lags(10)
corrgram ALGERIA, lags(10)
corrgram ARGENTINA, lags(10)
corrgram BAHAMAS, lags(10)
corrgram BARBADOS, lags(10)
corrgram BOLIVIA, lags(10)
corrgram BRAZIL, lags(10)
corrgram CHILE, lags(10)
corrgram COLOMBIA, lags(10)
corrgram COSTARICA, lags(10)
corrgram ELSALVADOR, lags(10)
corrgram GABON, lags(10)
corrgram GUATEMALA, lags(10)
corrgram JORDAN, lags(10)
corrgram MALAYSIA, lags(10)
corrgram MOROCCO, lags(10)
corrgram PAKISTAN, lags(10)
corrgram PARAGUAY, lags(10)
corrgram SOUTHAFRICA, lags(10)
corrgram SRILANKA, lags(10)
corrgram SWAZILAND, lags(10)
corrgram THAILAND, lags(10)
corrgram TUNISIA, lags(10)
corrgram TURKEY, lags(10)
corrgram BENIN, lags(10)
corrgram BURKINAFASO, lags(10)
corrgram BURUNDI, lags(10)
corrgram CAR, lags(10)
corrgram CHAD, lags(10)
corrgram RCONGO, lags(10)
corrgram GHANA, lags(10)
corrgram GRENADA, lags(10)
corrgram GUYANA, lags(10)
corrgram HAITI, lags(10)
corrgram HONDURAS, lags(10)
corrgram KENYA, lags(10)
corrgram LESOTHO, lags(10)
corrgram MADAGASCAR, lags(10)
corrgram MALI, lags(10)
corrgram NEPAL, lags(10)
corrgram NIGER, lags(10)
corrgram NIGERIA, lags(10)
corrgram PAPUANEWGUINEA, lags(10)
corrgram RWANDA, lags(10)
corrgram SAMOA, lags(10)
corrgram SENEGAL, lags(10)
corrgram SIERRALEONE, lags(10)
corrgram TOGO, lags(10)
corrgram ZAMBIA, lags(10)
*close log file to save the results of STATA .do commands
log close
*save gpdd.do file on Desktop
save "C:\Users\vlada\OneDrive\Desktop\gpdd.dta"
